Automations

Microsoft Commands

  • Version: 1.3.0
  • Official Verified
  • Depreciated Verified

OpenBots Command group containing Microsoft Interop commands (Excel, Outlook, Word).

OpenBots.Commands.Microsoft \ Excel Split Range By Column Command

Command: Excel Split Range By Column Command

This command takes a specific Excel range, splits it into separate ranges by column, and stores them in new Workbooks.

Parameters

Excel Instance Name

Enter the unique instance that was specified in the **Create Application** command.

Required

Range

Enter the location of the range to split.

Required

Column to Split

Enter the name of the column you wish to split the selected range by.

Required

Split Range Output Directory

Enter or Select the new directory for the split range files.

Required

Output File Type

Specify the file format type for the split range files.

Required

Output DataTable List Variable

Create a new variable or select a variable from the list.

Required

Private (Optional)

Optional field to mark the command as private (data sensitive) in order to avoid its logging.

Comment Field (Optional)

Optional field to enter a custom comment which could potentially describe this command or the need for this command, if required.

Logo